package com.model;

import com.jfinal.plugin.activerecord.Model;

public class TeachingSecretary extends Model<TeachingSecretary>{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	public static TeachingSecretary dao=new TeachingSecretary();
	
	/**
	 * 根据相应的系编号查找教学秘书id
	 */
	public Integer selecSecId(int depId)
	{		
		String sql="SELECT * FROM teachingsecretary where teachingsecretary.secretary_department = "+depId+"";
		return TeachingSecretary.dao.findFirst(sql).getInt("secretary_id");
	}

}
